package org.example.kg_back.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.example.kg_back.PoJo.entity.AtcDuty;

import java.util.List;

/**
 * @Author Colonnello
 * @Gitee https://gitee.com/niuzhengchao
 * @Date 2021/3/15 8:59
 */
@Mapper
public interface AtcDutyMapper extends BaseMapper<AtcDuty> {

	@Select("SELECT atc_duty_position,SUM(COUNT) as count " +
			"FROM atcduty_number " +
			"GROUP BY atc_duty_position;")
	List<AtcDuty> findATCDuty();
}
